package com.liyao.storehouse.dao;

import com.liyao.storehouse.pojo.intelligence.*;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface intelligenceDao {
    List<receiveLog> getToolReceiveLogList(@Param("page") int page, @Param("limit") int limit);

    int getToolReceiveLogListCount();

    List<receiveLogExcel> outGravityCabinetToolExcel(@Param("partDes") String partDes, @Param("location") String location, @Param("userName") String userName);

    List<receiveLog> SearchToolReceiveLogList(@Param("page") int page, @Param("limit") int limit, @Param("partDes") String partDes, @Param("location") String location, @Param("userName") String userName);

    int SearchToolReceiveLogListCount(@Param("partDes") String partDes, @Param("location") String location, @Param("userName") String userName);

    List<inOutLog> getInOutLogList(@Param("page") int page, @Param("limit") int limit);

    int getInOutLogListCount();

    List<inOutLogExcel> outInOutLogExcel(@Param("partDes") String partDes, @Param("location") String location, @Param("userName") String userName, @Param("onShelf") String onShelf);

    List<inOutLog> SearchInOutLogList(@Param("page") int page, @Param("limit") int limit, @Param("partDes") String partDes, @Param("location") String location, @Param("userName") String userName, @Param("onShelf") String onShelf);

    int SearchInOutLogListCount(@Param("partDes") String partDes, @Param("location") String location, @Param("userName") String userName, @Param("onShelf") String onShelf);

    List<goodsList> getGoodsList(@Param("page") int page, @Param("limit") int limit);

    int getGoodsListCount();

    List<goodsListExcel> outGoodsExcel(@Param("partDes") String partDes, @Param("location") String location, @Param("partNo") String  partNo);

    List<goodsList> SearchGoodsList(@Param("page") int page, @Param("limit") int limit, @Param("partDes") String partDes, @Param("location") String location, @Param("partNo") String  partNo);

    int SearchGoodsListCount(@Param("partDes") String partDes, @Param("location") String location, @Param("partNo") String  partNo);
}
